// Increase salary for specific job title employees //

use HAMMKudlerFineFoods
select *
from jobtitle j, Employee e
where j.jobjobID = e.jobjobID;


use HAMMKudlerFineFoods
update Employee
set empSalary = empSalary*1.04568
from jobtitle j, Employee e
where j.jobjobID = e.jobjobID and
j.jobjobClass = 'Manager & Executive';


use HAMMKudlerFineFoods
select *
from jobtitle j, Employee e
where j.jobjobID = e.jobjobID;

// Increase salary for all employees //

use HAMMKudlerFineFoods
select *
from jobtitle j, Employee e
where j.jobjobID = e.jobjobID;


use HAMMKudlerFineFoods
update Employee
set empSalary = empSalary*1.2091;


use HAMMKudlerFineFoods
select *
from jobtitle j, Employee e
where j.jobjobID = e.jobjobID;


// delete a specific employee using ID

use HAMMKudlerFineFoods
delete from Employee
where empID = 101;

// Avg emp employee salary //

use HAMMKudlerFineFoods
select avg(empsalary)
from employee;


// max employee salary //

use HAMMKudlerFineFoods
select max(empSalary)
from employee;


// min salary per job title

use HAMMKudlerFineFoods
select jobtitle, min(empSalary)
from employee e, jobtitle j
where e.jobjobID = j.jobjobID
group by jobtitle;

// min emp salary //

use HAMMKudlerFineFoods
select min(empSalary)
from employee;